{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from geopandas import GeoDataFrame\n",
    "import geopandas as gpd\n",
    "from shapely.geometry import Point,Polygon\n",
    "from geopy.geocoders import Nominatim\n",
    "from sodapy import Socrata\n",
    "import json\n",
    "import datetime\n",
    "import os\n",
    "from ipyleaflet import (\n",
    "    Map,\n",
    "    Marker,\n",
    "    TileLayer, ImageOverlay,\n",
    "    Polyline, Polygon, Rectangle, Circle, CircleMarker,\n",
    "    GeoJSON,\n",
    "    DrawControl\n",
    ")\n",
    "%reload_ext autoreload\n",
    "%autoreload 2\n",
    "\n",
    "# load api_keys\n",
    "with open(\"api_keys_kat.json\") as f:\n",
    "    keys = json.load(f)\n",
    "\n",
    "with open(\"apikeys.json\") as f:\n",
    "    planet_keys = json.load(f)\n",
    "\n",
    "PLANET_API_KEY = planet_keys[\"PLANET_API_KEY\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "LAX = keys[\"LAX\"]\n",
    "\n",
    "# Unauthenticated client only works with public data sets. Note 'None'\n",
    "# in place of application token, and no username or password:\n",
    "client = Socrata(LAX[\"url\"], \n",
    "                 LAX[\"key\"],\n",
    "                 username=LAX[\"username\"], \n",
    "                 password=LAX[\"password\"])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SELECT * WHERE issue_date > '2017-01-01' AND issue_date < '2017-12-31' AND valuation > 1000000\n"
     ]
    }
   ],
   "source": [
    "start_date = datetime.datetime(2017,1,1)\n",
    "end_date = datetime.datetime(2017,12,31)\n",
    "cost = 1000000\n",
    "query = \"SELECT * WHERE issue_date > '{0}' AND issue_date < '{1}' AND valuation > {2}\"\n",
    "query = query.format(start_date.strftime(\"%Y-%m-%d\"),end_date.strftime(\"%Y-%m-%d\"),cost)\n",
    "print(query)\n",
    "results = client.get(LAX[\"resource\"],query=query )\n",
    "results_df = pd.DataFrame.from_records(results)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "854\n",
      "Index([u'address_end', u'address_fraction_end', u'address_fraction_start',\n",
      "       u'address_start', u'applicant_address_1', u'applicant_address_2',\n",
      "       u'applicant_address_3', u'applicant_business_name',\n",
      "       u'applicant_first_name', u'applicant_last_name',\n",
      "       u'applicant_relationship', u'assessor_book', u'assessor_page',\n",
      "       u'assessor_parcel', u'block', u'census_tract', u'contractor_address',\n",
      "       u'contractor_city', u'contractor_state', u'contractors_business_name',\n",
      "       u'council_district', u'floor_area_l_a_building_code_definition',\n",
      "       u'floor_area_l_a_zoning_code_definition', u'initiating_office',\n",
      "       u'issue_date', u'latest_status', u'license', u'license_expiration_date',\n",
      "       u'license_type', u'location_1', u'lot', u'occupancy',\n",
      "       u'of_residential_dwelling_units', u'of_stories', u'pcis_permit',\n",
      "       u'permit_category', u'permit_sub_type', u'permit_type',\n",
      "       u'principal_first_name', u'principal_last_name',\n",
      "       u'principal_middle_name', u'project_number', u'reference_old_permit',\n",
      "       u'status_date', u'street_direction', u'street_name', u'street_suffix',\n",
      "       u'suffix_direction', u'tract', u'unit_range_end', u'unit_range_start',\n",
      "       u'valuation', u'work_description', u'zip_code', u'zone'],\n",
      "      dtype='object')\n",
      "0                                                    NaN\n",
      "1      {u'type': u'Point', u'coordinates': [-118.3998...\n",
      "2      {u'type': u'Point', u'coordinates': [-118.4126...\n",
      "3      {u'type': u'Point', u'coordinates': [-118.2141...\n",
      "4      {u'type': u'Point', u'coordinates': [-118.3723...\n",
      "5      {u'type': u'Point', u'coordinates': [-118.4592...\n",
      "6      {u'type': u'Point', u'coordinates': [-118.3034...\n",
      "7      {u'type': u'Point', u'coordinates': [-118.3531...\n",
      "8      {u'type': u'Point', u'coordinates': [-118.3738...\n",
      "9      {u'type': u'Point', u'coordinates': [-118.3719...\n",
      "10                                                   NaN\n",
      "11                                                   NaN\n",
      "12     {u'type': u'Point', u'coordinates': [-118.3390...\n",
      "13                                                   NaN\n",
      "14     {u'type': u'Point', u'coordinates': [-118.3575...\n",
      "15     {u'type': u'Point', u'coordinates': [-118.4485...\n",
      "16     {u'type': u'Point', u'coordinates': [-118.2549...\n",
      "17     {u'type': u'Point', u'coordinates': [-118.3922...\n",
      "18     {u'type': u'Point', u'coordinates': [-118.2763...\n",
      "19     {u'type': u'Point', u'coordinates': [-118.3738...\n",
      "20     {u'type': u'Point', u'coordinates': [-118.5041...\n",
      "21     {u'type': u'Point', u'coordinates': [-118.4183...\n",
      "22     {u'type': u'Point', u'coordinates': [-118.4882...\n",
      "23     {u'type': u'Point', u'coordinates': [-118.5844...\n",
      "24     {u'type': u'Point', u'coordinates': [-118.3388...\n",
      "25     {u'type': u'Point', u'coordinates': [-118.354,...\n",
      "26     {u'type': u'Point', u'coordinates': [-118.2596...\n",
      "27     {u'type': u'Point', u'coordinates': [-118.4195...\n",
      "28     {u'type': u'Point', u'coordinates': [-118.2405...\n",
      "29     {u'type': u'Point', u'coordinates': [-118.3189...\n",
      "                             ...                        \n",
      "824    {u'type': u'Point', u'coordinates': [-118.2701...\n",
      "825    {u'type': u'Point', u'coordinates': [-118.4602...\n",
      "826    {u'type': u'Point', u'coordinates': [-118.2649...\n",
      "827    {u'type': u'Point', u'coordinates': [-118.4808...\n",
      "828    {u'type': u'Point', u'coordinates': [-118.2893...\n",
      "829    {u'type': u'Point', u'coordinates': [-118.4106...\n",
      "830                                                  NaN\n",
      "831    {u'type': u'Point', u'coordinates': [-118.3679...\n",
      "832    {u'type': u'Point', u'coordinates': [-118.3758...\n",
      "833    {u'type': u'Point', u'coordinates': [-118.3864...\n",
      "834    {u'type': u'Point', u'coordinates': [-118.5552...\n",
      "835    {u'type': u'Point', u'coordinates': [-118.2829...\n",
      "836    {u'type': u'Point', u'coordinates': [-118.4848...\n",
      "837    {u'type': u'Point', u'coordinates': [-118.2863...\n",
      "838    {u'type': u'Point', u'coordinates': [-118.5552...\n",
      "839    {u'type': u'Point', u'coordinates': [-118.2538...\n",
      "840    {u'type': u'Point', u'coordinates': [-118.2829...\n",
      "841    {u'type': u'Point', u'coordinates': [-118.2418...\n",
      "842                                                  NaN\n",
      "843    {u'type': u'Point', u'coordinates': [-118.2585...\n",
      "844    {u'type': u'Point', u'coordinates': [-118.4871...\n",
      "845    {u'type': u'Point', u'coordinates': [-118.2705...\n",
      "846    {u'type': u'Point', u'coordinates': [-118.3065...\n",
      "847                                                  NaN\n",
      "848                                                  NaN\n",
      "849    {u'type': u'Point', u'coordinates': [-118.4169...\n",
      "850    {u'type': u'Point', u'coordinates': [-118.5552...\n",
      "851    {u'type': u'Point', u'coordinates': [-118.4132...\n",
      "852    {u'type': u'Point', u'coordinates': [-118.2523...\n",
      "853    {u'type': u'Point', u'coordinates': [-118.3540...\n",
      "Name: location_1, Length: 854, dtype: object\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address_end</th>\n",
       "      <th>address_fraction_end</th>\n",
       "      <th>address_fraction_start</th>\n",
       "      <th>address_start</th>\n",
       "      <th>applicant_address_1</th>\n",
       "      <th>applicant_address_2</th>\n",
       "      <th>applicant_address_3</th>\n",
       "      <th>applicant_business_name</th>\n",
       "      <th>applicant_first_name</th>\n",
       "      <th>applicant_last_name</th>\n",
       "      <th>...</th>\n",
       "      <th>street_name</th>\n",
       "      <th>street_suffix</th>\n",
       "      <th>suffix_direction</th>\n",
       "      <th>tract</th>\n",
       "      <th>unit_range_end</th>\n",
       "      <th>unit_range_start</th>\n",
       "      <th>valuation</th>\n",
       "      <th>work_description</th>\n",
       "      <th>zip_code</th>\n",
       "      <th>zone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>700</td>\n",
       "      <td>1715 W. 135TH</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GARDDENA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOSE</td>\n",
       "      <td>GUDIEL</td>\n",
       "      <td>...</td>\n",
       "      <td>WORLD</td>\n",
       "      <td>WAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RANCHO SAUSAL REDONDO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1379815</td>\n",
       "      <td>SUPPLEMENTAL PERMIT TO 15016-10000-08908.   DE...</td>\n",
       "      <td>90045</td>\n",
       "      <td>LAX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12828</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12828</td>\n",
       "      <td>23660 STRATHERN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>WEST HILLS,CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DOMINIC</td>\n",
       "      <td>HONG</td>\n",
       "      <td>...</td>\n",
       "      <td>RIVERSIDE</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 2590</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10500000</td>\n",
       "      <td>(N) HOTEL W/ SUBTERANEAN GARAGE BELOW</td>\n",
       "      <td>91607</td>\n",
       "      <td>(T)(Q)RAS4-1VL-RIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>OCCIDENTAL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>CAMPUS</td>\n",
       "      <td>ROAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 607</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000000</td>\n",
       "      <td>FOUNDATION EARLY START PERMIT ONLY. THIS APPLI...</td>\n",
       "      <td>90032</td>\n",
       "      <td>R1-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>11050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11050</td>\n",
       "      <td>1453 CLUB VIEW DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LA,CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FRANK</td>\n",
       "      <td>AFARI</td>\n",
       "      <td>...</td>\n",
       "      <td>HARTSOOK</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HARTSOOK TRACT</td>\n",
       "      <td>48</td>\n",
       "      <td>1</td>\n",
       "      <td>6008535</td>\n",
       "      <td>NEW 3-STORY TYPE V-A, 48-UNIT APARTMENT BUILDI...</td>\n",
       "      <td>91601</td>\n",
       "      <td>R4-1VL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>11000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11000</td>\n",
       "      <td>1636 WESTWOOD BL</td>\n",
       "      <td>#201</td>\n",
       "      <td>L.A., CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JASON</td>\n",
       "      <td>MASSABAND</td>\n",
       "      <td>...</td>\n",
       "      <td>CHALON</td>\n",
       "      <td>ROAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BEL-AIR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1600000</td>\n",
       "      <td>New irregular shape 2- story over 1- level of ...</td>\n",
       "      <td>90077</td>\n",
       "      <td>RE20-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1522</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1522</td>\n",
       "      <td>3456 GOLDEN POPPY WAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>YORBA LINDA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHEHZAD</td>\n",
       "      <td>KHALIQ</td>\n",
       "      <td>...</td>\n",
       "      <td>LOMITA</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 1589</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-14</td>\n",
       "      <td>2000000</td>\n",
       "      <td>NEW 14 UNIT APARTMENT BUILDING</td>\n",
       "      <td>90710</td>\n",
       "      <td>[Q]R3-1VL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>5135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5135</td>\n",
       "      <td>3834 WILLAT AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CULVER CITY, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>STD</td>\n",
       "      <td>LEMONS</td>\n",
       "      <td>...</td>\n",
       "      <td>ADAMS</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 1566</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>1925000</td>\n",
       "      <td>PROPOSED 3-STORY, 10-UNIT MIXED USE BUILDING W...</td>\n",
       "      <td>90016</td>\n",
       "      <td>C2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>5101</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5101</td>\n",
       "      <td>232 N LAKE AVE</td>\n",
       "      <td>STE 217</td>\n",
       "      <td>PASADENA, CA</td>\n",
       "      <td>JAYCOCAL ENGINEERING</td>\n",
       "      <td>MARIA</td>\n",
       "      <td>CHEN</td>\n",
       "      <td>...</td>\n",
       "      <td>LANKERSHIM</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 2170</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40000000</td>\n",
       "      <td>INSTALLATION OF NEW PLUMBING SYSTEM FOR (2) MI...</td>\n",
       "      <td>91601</td>\n",
       "      <td>C4-1-CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>11051</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11051</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARCUS</td>\n",
       "      <td>PARIS</td>\n",
       "      <td>...</td>\n",
       "      <td>PENDLETON</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LOS ANGELES LAND AND WATER CO'S SUBDIVISION OF...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1200000</td>\n",
       "      <td>TI to existing Warehouse to build out accessor...</td>\n",
       "      <td>91352</td>\n",
       "      <td>[Q]M2-1-G-CUGU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>6801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6801</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALEX</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>HOLLYWOOD</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 52496</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C5-525</td>\n",
       "      <td>1800000</td>\n",
       "      <td>TI at  restaurant  on  the  5th  floor. ENCLOS...</td>\n",
       "      <td>90028</td>\n",
       "      <td>C4-2D-SN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5263</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5263</td>\n",
       "      <td>4700 WILSHIRE BL.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LA CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRAM</td>\n",
       "      <td>JANANTS</td>\n",
       "      <td>...</td>\n",
       "      <td>ADAMS</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 1566</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3237681</td>\n",
       "      <td>NEW 3 STORY MIXED USE,  14 UNIT   APARTEMENT B...</td>\n",
       "      <td>90016</td>\n",
       "      <td>[Q]C2-1VL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>11916</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11916</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BMA</td>\n",
       "      <td>KIRA</td>\n",
       "      <td>MILLER</td>\n",
       "      <td>...</td>\n",
       "      <td>PICO</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 7861</td>\n",
       "      <td>100</td>\n",
       "      <td>1</td>\n",
       "      <td>16188702</td>\n",
       "      <td>PROPOSED 5-STORY, 100 UNIT MIXED USE (97 UNITS...</td>\n",
       "      <td>90064</td>\n",
       "      <td>[Q]C2-1VL-CDO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>410</td>\n",
       "      <td>8970 WASHINGTON BL.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CULVER CITY, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JEFFREY</td>\n",
       "      <td>WARREN</td>\n",
       "      <td>...</td>\n",
       "      <td>7TH</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MUELLER SUBDIVISION OF THE NORTH 1/2 OF BLOCK ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3300000</td>\n",
       "      <td>SEISMIC UPGRADE OF 3 STORY CAST-IN-PLACE CONCR...</td>\n",
       "      <td>90014</td>\n",
       "      <td>C5-4D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>9005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9005</td>\n",
       "      <td>401 S. WESTGATE AVE.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LOS ANGELES, CA.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JAVAD</td>\n",
       "      <td>NIA</td>\n",
       "      <td>...</td>\n",
       "      <td>EXPOSITION</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 625</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1363658.4</td>\n",
       "      <td>New 4-story office building with parking on th...</td>\n",
       "      <td>90034</td>\n",
       "      <td>M1-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2601</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2601</td>\n",
       "      <td>1330 OLYMPIC BL.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SANTA MONICA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JOHN</td>\n",
       "      <td>DODSON</td>\n",
       "      <td>...</td>\n",
       "      <td>FIGUEROA</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 10196</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1st floor</td>\n",
       "      <td>1235000</td>\n",
       "      <td>Interior TI in existing ground floor office bu...</td>\n",
       "      <td>90007</td>\n",
       "      <td>P-1-O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5101</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5101</td>\n",
       "      <td>232 N LAKE AVE</td>\n",
       "      <td>STE 217</td>\n",
       "      <td>PASADENA, CA</td>\n",
       "      <td>JAYCOCAL ENGINEERING</td>\n",
       "      <td>MARIA</td>\n",
       "      <td>CHEN</td>\n",
       "      <td>...</td>\n",
       "      <td>LANKERSHIM</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 2170</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40000000</td>\n",
       "      <td>INSTALLATION OF NEW HVAC SYSTEM FOR (2) MIXED ...</td>\n",
       "      <td>91601</td>\n",
       "      <td>C4-1-CA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DAMIAN</td>\n",
       "      <td>LEMONS</td>\n",
       "      <td>...</td>\n",
       "      <td>AMALFI</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>THE RIVIERA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1400000</td>\n",
       "      <td>new 2 story + basement s.f.r.</td>\n",
       "      <td>90272</td>\n",
       "      <td>RE15-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>11830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PETER</td>\n",
       "      <td>WILSON</td>\n",
       "      <td>...</td>\n",
       "      <td>COURTLEIGH</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 1971</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000000</td>\n",
       "      <td>new 29 unit apartment building 4 levels of res...</td>\n",
       "      <td>90066</td>\n",
       "      <td>R3-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JASON</td>\n",
       "      <td>UNGAR</td>\n",
       "      <td>...</td>\n",
       "      <td>BRISTOL</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRENTWOOD PARK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1900000</td>\n",
       "      <td>new 2-story SFD with attached garage and basement</td>\n",
       "      <td>90049</td>\n",
       "      <td>RE20-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>20701</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20701</td>\n",
       "      <td>26901 CAMINO DE ESTRELLA</td>\n",
       "      <td>#A</td>\n",
       "      <td>CAPISTRANO BCH, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JAMES</td>\n",
       "      <td>GOODMAN</td>\n",
       "      <td>...</td>\n",
       "      <td>PLUMMER</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 23435</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1615500</td>\n",
       "      <td>INSTALL 9 FIRE SPRINKLERS IN NEW 1-HR HALLWAY ...</td>\n",
       "      <td>91311</td>\n",
       "      <td>MR2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1233</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1233</td>\n",
       "      <td>833 S SPRING</td>\n",
       "      <td>#208</td>\n",
       "      <td>LA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KEVIN</td>\n",
       "      <td>TSAI</td>\n",
       "      <td>...</td>\n",
       "      <td>HIGHLAND</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 3569</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18953537</td>\n",
       "      <td>72 UNITS AFFORDABLE APARTMENTS OVER RETAIL AND...</td>\n",
       "      <td>90038</td>\n",
       "      <td>C2-1D-SN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>10241</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10241</td>\n",
       "      <td>5320 YOLANDA AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TARZANA,CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDREA</td>\n",
       "      <td>SHAPIRO</td>\n",
       "      <td>...</td>\n",
       "      <td>VALLEY SPRING</td>\n",
       "      <td>LANE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LANKERSHIM RANCH LAND AND WATER CO.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1144000</td>\n",
       "      <td>(N) SFD W/ ATT GARAGE</td>\n",
       "      <td>91602</td>\n",
       "      <td>RE11-1-H-RIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>900</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>900</td>\n",
       "      <td>515 S. FIGUEROA</td>\n",
       "      <td>1275</td>\n",
       "      <td>LA CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JUSTIN</td>\n",
       "      <td>MANALO</td>\n",
       "      <td>...</td>\n",
       "      <td>WILSHIRE</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 71141-01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11th floor</td>\n",
       "      <td>2000000</td>\n",
       "      <td>INTERIOR TI ON 11TH FLOOR  INCLUDING NEW PARTI...</td>\n",
       "      <td>90017</td>\n",
       "      <td>C2-4D-SN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>7157</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7157</td>\n",
       "      <td>765 THE CITY DRIVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ORANGE, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>STANEK</td>\n",
       "      <td>...</td>\n",
       "      <td>WORLD</td>\n",
       "      <td>WAY</td>\n",
       "      <td>WEST</td>\n",
       "      <td>RANCHO SAUSAL REDONDO</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5241000</td>\n",
       "      <td>REPLACE 8\"  COMBINED DOMESTIC / FIRE SERVICE L...</td>\n",
       "      <td>90045</td>\n",
       "      <td>LAX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1318</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1318</td>\n",
       "      <td>8 MILLS PLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PASADENA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHAWNA</td>\n",
       "      <td>UPP</td>\n",
       "      <td>...</td>\n",
       "      <td>7TH</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>P M 6524</td>\n",
       "      <td>NaN</td>\n",
       "      <td>STE 260</td>\n",
       "      <td>1573000</td>\n",
       "      <td>TENANT IMPROVEMENT TO EXISTING OFFICE SPACE ON...</td>\n",
       "      <td>90021</td>\n",
       "      <td>M2-2D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1310</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1310</td>\n",
       "      <td>126 E OLIVE AVE</td>\n",
       "      <td>204</td>\n",
       "      <td>BURBANK, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHAHIK</td>\n",
       "      <td>BAGHDASIAN</td>\n",
       "      <td>...</td>\n",
       "      <td>TAMARIND</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GRIDER AND HAMILTONS HOLLYWOOD TRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6300000</td>\n",
       "      <td>NEW 4 STORY TYPE V-A  32 UNIT APARTMENT BUILDI...</td>\n",
       "      <td>90028</td>\n",
       "      <td>[Q]R4-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>10250</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10250</td>\n",
       "      <td>8370 WILSHIRE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BEVERLY HILLS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JULIA</td>\n",
       "      <td>AUST</td>\n",
       "      <td>...</td>\n",
       "      <td>SANTA MONICA</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>P M 3784</td>\n",
       "      <td>NaN</td>\n",
       "      <td>UNIT 2540</td>\n",
       "      <td>1428341</td>\n",
       "      <td>T.I. FOR EXISTING RETAIL STORE (UNIT #2540 ); ...</td>\n",
       "      <td>90067</td>\n",
       "      <td>C2-1L-O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1446</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1446</td>\n",
       "      <td>830 S. GLENDALE AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GLENDALE, CA</td>\n",
       "      <td>URIU &amp; ASSOCIATES</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DETROIT</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 3238</td>\n",
       "      <td>1-60</td>\n",
       "      <td>1-60</td>\n",
       "      <td>12120505</td>\n",
       "      <td>PROPOSED  5 STORY,  MIXED USE BUILDING CONSIST...</td>\n",
       "      <td>90046</td>\n",
       "      <td>R3-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>350</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>350</td>\n",
       "      <td>588 S FREMONT AVE  #803</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BRUCE MILLER</td>\n",
       "      <td>&amp; ASSOC</td>\n",
       "      <td>...</td>\n",
       "      <td>GRAND</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 30780</td>\n",
       "      <td>2,4,5,6,7</td>\n",
       "      <td>LEVEL</td>\n",
       "      <td>6290625</td>\n",
       "      <td>TENANT IMPROVEMENT OF 5 LEVELS.  EACH LEVEL IS...</td>\n",
       "      <td>90071</td>\n",
       "      <td>C2-4D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>4824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4824</td>\n",
       "      <td>11315 WASHINGTON PLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LOS ANGELES, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DAVID</td>\n",
       "      <td>FRUCHTMAN</td>\n",
       "      <td>...</td>\n",
       "      <td>SUNNYSLOPE</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 1000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4D</td>\n",
       "      <td>7883566</td>\n",
       "      <td>NEW 26 UNIT, 3-STORY APARTMENT BUILDING. PLAN ...</td>\n",
       "      <td>91423</td>\n",
       "      <td>[Q]RD1.5-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>13741</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13741</td>\n",
       "      <td>11558 KLING ST.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>N. HOLLYWOOD CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FRED</td>\n",
       "      <td>HOFFMAN</td>\n",
       "      <td>...</td>\n",
       "      <td>MULHOLLAND</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 1000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1500000</td>\n",
       "      <td>NEW 2-STORY SFD WITH ATT.  GARAGE &amp; BASEMENT. ...</td>\n",
       "      <td>90210</td>\n",
       "      <td>RE40-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>821</th>\n",
       "      <td>16144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16144</td>\n",
       "      <td>15230 BURBANK BLVD</td>\n",
       "      <td>#106</td>\n",
       "      <td>SHERMAN OAKS,CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CAMILLA</td>\n",
       "      <td>OLIVEISE</td>\n",
       "      <td>...</td>\n",
       "      <td>HIGH VALLEY</td>\n",
       "      <td>PL</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 13400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1437675</td>\n",
       "      <td>97'-0\" x 107'-0\" TWO STORY SINGLE FAMILY DWELL...</td>\n",
       "      <td>91436</td>\n",
       "      <td>RE15-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>241</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>241</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GEORGE</td>\n",
       "      <td>SEPANOSSIAN</td>\n",
       "      <td>...</td>\n",
       "      <td>LAKE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HARBERT AND BUTTERWORTH'S CUMBERLAND TRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000000</td>\n",
       "      <td>NEW HVAC SYSTEM FOR APARTMENT BUILDING.  INCLU...</td>\n",
       "      <td>90026</td>\n",
       "      <td>R4-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823</th>\n",
       "      <td>4522</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4522</td>\n",
       "      <td>3200 PEAK ROAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EL MONTE, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATTHEW</td>\n",
       "      <td>FOSS</td>\n",
       "      <td>...</td>\n",
       "      <td>LEXINGTON</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CITY BOUNDARY TRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1500000</td>\n",
       "      <td>NEW 9-UNIT APARTMENT BUILDING 2 STORY OVER BAS...</td>\n",
       "      <td>90029</td>\n",
       "      <td>RD1.5-1XL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>241</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>241</td>\n",
       "      <td>3699 WILSHIRE BLVD</td>\n",
       "      <td>#660</td>\n",
       "      <td>LOS ANGELES, CA</td>\n",
       "      <td>JS ENGINEERING</td>\n",
       "      <td>CHONG</td>\n",
       "      <td>LEE</td>\n",
       "      <td>...</td>\n",
       "      <td>LAKE</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HARBERT AND BUTTERWORTH'S CUMBERLAND TRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5000000</td>\n",
       "      <td>NEW POTABLE WATER AND WASTE/VENT SYSTEM FOR FO...</td>\n",
       "      <td>90026</td>\n",
       "      <td>R4-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>11100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MSH DESIGN INC</td>\n",
       "      <td>MEHRAN</td>\n",
       "      <td>SHAHVERDI</td>\n",
       "      <td>...</td>\n",
       "      <td>CHALON</td>\n",
       "      <td>ROAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SANTA MONICA LAND AND WATER CO. TRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5600000</td>\n",
       "      <td>(N) 2 story SFD with basement and attached gar...</td>\n",
       "      <td>90049</td>\n",
       "      <td>RE20-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>6130</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6130</td>\n",
       "      <td>18201 VON KARMAN AVE</td>\n",
       "      <td>120</td>\n",
       "      <td>IRVINE, CA</td>\n",
       "      <td>SHLEMMER ALGAZE ASSOCIATES</td>\n",
       "      <td>MICHAEL</td>\n",
       "      <td>SYNDER</td>\n",
       "      <td>...</td>\n",
       "      <td>AVALON</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BLDG.A</td>\n",
       "      <td>1500000</td>\n",
       "      <td>&lt;URM&gt;CHANGE OF USE FROM \"STORAGE\" TO \"FOOD MAN...</td>\n",
       "      <td>90003</td>\n",
       "      <td>M2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>15970</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15970</td>\n",
       "      <td>5320 YOLANDA AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TARZANA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDREA</td>\n",
       "      <td>SHAPIRO</td>\n",
       "      <td>...</td>\n",
       "      <td>ROYAL OAK</td>\n",
       "      <td>ROAD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 13400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1180000</td>\n",
       "      <td>(N) 2-STORY SFD W/ ATTACHED GARAGE (NFPA-13D F...</td>\n",
       "      <td>91436</td>\n",
       "      <td>RE15-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>1342</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1314</td>\n",
       "      <td>1623 THOMPSON AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GLENDALE, CA</td>\n",
       "      <td>G&amp;M ENGINEERING</td>\n",
       "      <td>GEORGE</td>\n",
       "      <td>MARKOV</td>\n",
       "      <td>...</td>\n",
       "      <td>ADAMS</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ELLENDALE PLACE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1500000</td>\n",
       "      <td>INSTALLATION OF ONE DUPLEX SUMP PUMP SYSTEM FO...</td>\n",
       "      <td>90007</td>\n",
       "      <td>R4-1L-O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>829</th>\n",
       "      <td>3550</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3550</td>\n",
       "      <td>1544 20TH ST.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SANTA MONICA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SANDRA</td>\n",
       "      <td>LOZANO</td>\n",
       "      <td>...</td>\n",
       "      <td>OVERLAND</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CURTIS RESUB. OF BLK. P</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9332001</td>\n",
       "      <td>New 5-story 60-unit apartment (6-unit very low...</td>\n",
       "      <td>90034</td>\n",
       "      <td>C2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>831</th>\n",
       "      <td>6399</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6399</td>\n",
       "      <td>3334 EAST COAST HWY #410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CORONA DEL MAR, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HANNAH</td>\n",
       "      <td>GREENBERG</td>\n",
       "      <td>...</td>\n",
       "      <td>WILSHIRE</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 7555</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12000000</td>\n",
       "      <td>NON-DUCTILE SEISMIC RETROFIT PER CHAPTER 95. C...</td>\n",
       "      <td>90048</td>\n",
       "      <td>[Q]C4-2D-O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>832</th>\n",
       "      <td>8517</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8517</td>\n",
       "      <td>241 SOUTH FIGUEROA STREET</td>\n",
       "      <td>370</td>\n",
       "      <td>LOS ANGELES, CA</td>\n",
       "      <td>KIMBERLINA WHETTAM &amp; ASSOCIATE</td>\n",
       "      <td>KARA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>FRANKLIN</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 8500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1200000</td>\n",
       "      <td>SINGLE FAMILY DWELLING. INSTALL SUMP PUMP AND ...</td>\n",
       "      <td>90069</td>\n",
       "      <td>R1-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>1561</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1561</td>\n",
       "      <td>11150 W OLYMPIC BLVD#700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CHRISTINE</td>\n",
       "      <td>MAALOUF</td>\n",
       "      <td>...</td>\n",
       "      <td>BLUE JAY</td>\n",
       "      <td>WAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 19229</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1560000</td>\n",
       "      <td>NEW 1-STORY S.F.D. WITH  BASEMENT.</td>\n",
       "      <td>90069</td>\n",
       "      <td>RE15-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>834</th>\n",
       "      <td>17320</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17320</td>\n",
       "      <td>8447 WILSHIRE BL</td>\n",
       "      <td>400</td>\n",
       "      <td>BEVERLY HILLS, CA</td>\n",
       "      <td>ETCO HOMES</td>\n",
       "      <td>E</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>TRAMONTO</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 29827-C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-3</td>\n",
       "      <td>2462574</td>\n",
       "      <td>BUILDING 9 (PLAN C) 3 UNITS 4 STORY TYPE IIA A...</td>\n",
       "      <td>90272</td>\n",
       "      <td>RD2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>835</th>\n",
       "      <td>12919</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12919</td>\n",
       "      <td>717 N HIGHLAND AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LOS ANGELES, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATT</td>\n",
       "      <td>EOKBERG</td>\n",
       "      <td>...</td>\n",
       "      <td>FIGUEROA</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 45085</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2757900</td>\n",
       "      <td>CONVERT WAREHOUSE TO OFFICE AND MANUFACTURING,...</td>\n",
       "      <td>90248</td>\n",
       "      <td>M2-1VL-O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>836</th>\n",
       "      <td>4467</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4467</td>\n",
       "      <td>13547 VENTURA BLVD</td>\n",
       "      <td>283</td>\n",
       "      <td>SHERMAN OAKS, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CHARLENE</td>\n",
       "      <td>MARTIN</td>\n",
       "      <td>...</td>\n",
       "      <td>WOODLEY</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>P M 2458</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1650000</td>\n",
       "      <td>New 2- story irregular shape single family dwe...</td>\n",
       "      <td>91436</td>\n",
       "      <td>RE15-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>837</th>\n",
       "      <td>3976</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3966</td>\n",
       "      <td>1619 W TEMPLE ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LOS ANGELES, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>KRYSTLE</td>\n",
       "      <td>REYES</td>\n",
       "      <td>...</td>\n",
       "      <td>MELROSE</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 525</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5794555</td>\n",
       "      <td>24 UNIT MIXED USED RESIDENTIAL BUILDING. TWO L...</td>\n",
       "      <td>90029</td>\n",
       "      <td>C2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>838</th>\n",
       "      <td>17314</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17314</td>\n",
       "      <td>8447 WILSHIRE BLVD  #400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BEVERLY HILLS, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ETCO</td>\n",
       "      <td>HOMES</td>\n",
       "      <td>...</td>\n",
       "      <td>TRAMONTO</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 29827-C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-2</td>\n",
       "      <td>1296796</td>\n",
       "      <td>BUILDING 8 (PLAN B2)  2 UNITS  AND 2 STORY TYP...</td>\n",
       "      <td>90272</td>\n",
       "      <td>RD2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>601</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>601</td>\n",
       "      <td>639 N LARCHMONT BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ANDY</td>\n",
       "      <td>LANTZ</td>\n",
       "      <td>...</td>\n",
       "      <td>5TH</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NORMAL TRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FLR 4&amp;11</td>\n",
       "      <td>1750000</td>\n",
       "      <td>REMOVAL FIVE EXISTING GREENHOUSE ENCLOSURES ON...</td>\n",
       "      <td>90071</td>\n",
       "      <td>C2-4D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>840</th>\n",
       "      <td>3939</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3939</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARK</td>\n",
       "      <td>JOSTEN</td>\n",
       "      <td>...</td>\n",
       "      <td>FIGUEROA</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 4719</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16000000</td>\n",
       "      <td>NEW TWO STORIES ANCILLARY BUILDING WITH ROOF D...</td>\n",
       "      <td>90037</td>\n",
       "      <td>OS-1XL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>841</th>\n",
       "      <td>118</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>118</td>\n",
       "      <td>9560 WILSHIRE BLVD.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BEVERLY HILLS, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MATT</td>\n",
       "      <td>HANSON</td>\n",
       "      <td>...</td>\n",
       "      <td>ASTRONAUT ELLISON S ONIZUKA</td>\n",
       "      <td>ST</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 1666</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000000</td>\n",
       "      <td>PROPOSE 471'-0\" LONG WITH MAX. 33'-0\" HEIGHT T...</td>\n",
       "      <td>90012</td>\n",
       "      <td>[Q]C2-4D-CDO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>843</th>\n",
       "      <td>2600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2600</td>\n",
       "      <td>11878 LA GRANGE AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LOS ANGELES, CA</td>\n",
       "      <td>GMPA ARCHITECTS INC</td>\n",
       "      <td>GMPA</td>\n",
       "      <td>ARCHITECTS INC</td>\n",
       "      <td>...</td>\n",
       "      <td>RIVERSIDE</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>IVANHOE</td>\n",
       "      <td>120</td>\n",
       "      <td>1</td>\n",
       "      <td>2515428</td>\n",
       "      <td>Temporary shoring (piles only) for new 4-story...</td>\n",
       "      <td>90039</td>\n",
       "      <td>RD2-1VL-RIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>844</th>\n",
       "      <td>601</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>601</td>\n",
       "      <td>21777 VENTURA BLVD</td>\n",
       "      <td>234</td>\n",
       "      <td>WOODLAND HILLS</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RJ</td>\n",
       "      <td>TORBATI</td>\n",
       "      <td>...</td>\n",
       "      <td>HANLEY</td>\n",
       "      <td>WAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 13362</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1700000</td>\n",
       "      <td>new 2 story + basement Single Family dwelling</td>\n",
       "      <td>90049</td>\n",
       "      <td>RE15-1-H</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>845</th>\n",
       "      <td>4501</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4501</td>\n",
       "      <td>650 CALIFORNIA ST</td>\n",
       "      <td>8TH FLR</td>\n",
       "      <td>LOS ANGELES, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FLAD&amp;</td>\n",
       "      <td>ASSOC</td>\n",
       "      <td>...</td>\n",
       "      <td>COLORADO</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>P M 2631</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5th FL</td>\n",
       "      <td>1329570</td>\n",
       "      <td>CHANGE OF USE FROM OFFICE TO CONTROL TEST LAB;...</td>\n",
       "      <td>90039</td>\n",
       "      <td>M3-1-RIO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>846</th>\n",
       "      <td>1011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1011</td>\n",
       "      <td>2932 WILSHIRE BLVD.</td>\n",
       "      <td># 210</td>\n",
       "      <td>SANTA MONICA, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>DARYOUS</td>\n",
       "      <td>SAFAI</td>\n",
       "      <td>...</td>\n",
       "      <td>SERRANO</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PELLISSIER TRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15928730</td>\n",
       "      <td>PROPOSED 5-STORY, 104-UNIT APARTMENT WITH (9) ...</td>\n",
       "      <td>90006</td>\n",
       "      <td>C2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>849</th>\n",
       "      <td>10100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10100</td>\n",
       "      <td>9530 JEFFERSON BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>CULVER CITY, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>BOB</td>\n",
       "      <td>CULL</td>\n",
       "      <td>...</td>\n",
       "      <td>SANTA MONICA</td>\n",
       "      <td>BLVD</td>\n",
       "      <td>NaN</td>\n",
       "      <td>P M 3247</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1500</td>\n",
       "      <td>1245240</td>\n",
       "      <td>TENANT IMPROVEMENT OF FULL FLOOR LEVEL-15 WITH...</td>\n",
       "      <td>90067</td>\n",
       "      <td>C2-2-O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>850</th>\n",
       "      <td>17330</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17330</td>\n",
       "      <td>6087 TRIANGLE DRIVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>LOS ANGELES, CA</td>\n",
       "      <td>THYSSEN KRUPP ELEVATOR</td>\n",
       "      <td>MARICELA</td>\n",
       "      <td>ESTRADA</td>\n",
       "      <td>...</td>\n",
       "      <td>TRAMONTO</td>\n",
       "      <td>DR</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 29827-C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1-8</td>\n",
       "      <td>14400204</td>\n",
       "      <td>INSTALL HYDRAULIC ELEVATORS.</td>\n",
       "      <td>90272</td>\n",
       "      <td>RD2-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>851</th>\n",
       "      <td>4513</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4505</td>\n",
       "      <td>578 WASHINGTON BLVD  #941</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARINA DEL REY, CA</td>\n",
       "      <td>OWNER-BUILDER</td>\n",
       "      <td>HUNTER</td>\n",
       "      <td>KENIHAN</td>\n",
       "      <td>...</td>\n",
       "      <td>SLAUSON</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 10200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3900000</td>\n",
       "      <td>(N) 23 UNIT (21 MARKET RATE, 2 VLI AFFORDABLE)...</td>\n",
       "      <td>90230</td>\n",
       "      <td>R3-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>852</th>\n",
       "      <td>620</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>620</td>\n",
       "      <td>8370 WILSHIRE BLVD</td>\n",
       "      <td>SUITE 330</td>\n",
       "      <td>BEVERLY HILLS, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MARTHA</td>\n",
       "      <td>DIAZ</td>\n",
       "      <td>...</td>\n",
       "      <td>BROADWAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>VICTOR DOL PROPERTY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3800000</td>\n",
       "      <td>Core and shell only.  Structural upgrade to ex...</td>\n",
       "      <td>90014</td>\n",
       "      <td>[Q]C5-4D-CDO-SN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>853</th>\n",
       "      <td>1333</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1333</td>\n",
       "      <td>1545 VICTORY BLVD.</td>\n",
       "      <td>#102</td>\n",
       "      <td>GLENDALE, CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>MOHEB</td>\n",
       "      <td>GORGY</td>\n",
       "      <td>...</td>\n",
       "      <td>SIERRA BONITA</td>\n",
       "      <td>AVE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TR 461</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2400000</td>\n",
       "      <td>NEW 4 STORY TYPE V-A ,  6-UNIT APARTMENT BUILD...</td>\n",
       "      <td>90046</td>\n",
       "      <td>R3-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>741 rows × 55 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    address_end address_fraction_end address_fraction_start address_start  \\\n",
       "1           700                  NaN                    NaN           700   \n",
       "2         12828                  NaN                    NaN         12828   \n",
       "3          1600                  NaN                    NaN          1600   \n",
       "4         11050                  NaN                    NaN         11050   \n",
       "5         11000                  NaN                    NaN         11000   \n",
       "6          1522                  NaN                    NaN          1522   \n",
       "7          5135                  NaN                    NaN          5135   \n",
       "8          5101                  NaN                    NaN          5101   \n",
       "9         11051                  NaN                    NaN         11051   \n",
       "12         6801                  NaN                    NaN          6801   \n",
       "14         5263                  NaN                    NaN          5263   \n",
       "15        11916                  NaN                    NaN         11916   \n",
       "16          410                  NaN                    NaN           410   \n",
       "17         9005                  NaN                    NaN          9005   \n",
       "18         2601                  NaN                    NaN          2601   \n",
       "19         5101                  NaN                    NaN          5101   \n",
       "20         1555                  NaN                    NaN          1555   \n",
       "21        11830                  NaN                    NaN         11830   \n",
       "22          144                  NaN                    NaN           144   \n",
       "23        20701                  NaN                    NaN         20701   \n",
       "24         1233                  NaN                    NaN          1233   \n",
       "25        10241                  NaN                    NaN         10241   \n",
       "26          900                  NaN                    NaN           900   \n",
       "27         7157                  NaN                    NaN          7157   \n",
       "28         1318                  NaN                    NaN          1318   \n",
       "29         1310                  NaN                    NaN          1310   \n",
       "30        10250                  NaN                    NaN         10250   \n",
       "31         1446                  NaN                    NaN          1446   \n",
       "32          350                  NaN                    NaN           350   \n",
       "33         4824                  NaN                    NaN          4824   \n",
       "..          ...                  ...                    ...           ...   \n",
       "820       13741                  NaN                    NaN         13741   \n",
       "821       16144                  NaN                    NaN         16144   \n",
       "822         241                  NaN                    NaN           241   \n",
       "823        4522                  NaN                    NaN          4522   \n",
       "824         241                  NaN                    NaN           241   \n",
       "825       11100                  NaN                    NaN         11100   \n",
       "826        6130                  NaN                    NaN          6130   \n",
       "827       15970                  NaN                    NaN         15970   \n",
       "828        1342                  NaN                    NaN          1314   \n",
       "829        3550                  NaN                    NaN          3550   \n",
       "831        6399                  NaN                    NaN          6399   \n",
       "832        8517                  NaN                    NaN          8517   \n",
       "833        1561                  NaN                    NaN          1561   \n",
       "834       17320                  NaN                    NaN         17320   \n",
       "835       12919                  NaN                    NaN         12919   \n",
       "836        4467                  NaN                    NaN          4467   \n",
       "837        3976                  NaN                    NaN          3966   \n",
       "838       17314                  NaN                    NaN         17314   \n",
       "839         601                  NaN                    NaN           601   \n",
       "840        3939                  NaN                    NaN          3939   \n",
       "841         118                  NaN                    NaN           118   \n",
       "843        2600                  NaN                    NaN          2600   \n",
       "844         601                  NaN                    NaN           601   \n",
       "845        4501                  NaN                    NaN          4501   \n",
       "846        1011                  NaN                    NaN          1011   \n",
       "849       10100                  NaN                    NaN         10100   \n",
       "850       17330                  NaN                    NaN         17330   \n",
       "851        4513                  NaN                    NaN          4505   \n",
       "852         620                  NaN                    NaN           620   \n",
       "853        1333                  NaN                    NaN          1333   \n",
       "\n",
       "           applicant_address_1 applicant_address_2 applicant_address_3  \\\n",
       "1                1715 W. 135TH                 NaN        GARDDENA, CA   \n",
       "2              23660 STRATHERN                 NaN       WEST HILLS,CA   \n",
       "3                          NaN                 NaN                 NaN   \n",
       "4            1453 CLUB VIEW DR                 NaN               LA,CA   \n",
       "5             1636 WESTWOOD BL                #201            L.A., CA   \n",
       "6        3456 GOLDEN POPPY WAY                 NaN     YORBA LINDA, CA   \n",
       "7              3834 WILLAT AVE                 NaN     CULVER CITY, CA   \n",
       "8               232 N LAKE AVE             STE 217        PASADENA, CA   \n",
       "9                          NaN                 NaN                 NaN   \n",
       "12                         NaN                 NaN                 NaN   \n",
       "14           4700 WILSHIRE BL.                 NaN               LA CA   \n",
       "15                         NaN                 NaN                 NaN   \n",
       "16         8970 WASHINGTON BL.                 NaN     CULVER CITY, CA   \n",
       "17        401 S. WESTGATE AVE.                 NaN    LOS ANGELES, CA.   \n",
       "18            1330 OLYMPIC BL.                 NaN    SANTA MONICA, CA   \n",
       "19              232 N LAKE AVE             STE 217        PASADENA, CA   \n",
       "20                         NaN                 NaN                 NaN   \n",
       "21                         NaN                 NaN                 NaN   \n",
       "22                         NaN                 NaN                 NaN   \n",
       "23    26901 CAMINO DE ESTRELLA                  #A  CAPISTRANO BCH, CA   \n",
       "24                833 S SPRING                #208              LA, CA   \n",
       "25            5320 YOLANDA AVE                 NaN          TARZANA,CA   \n",
       "26             515 S. FIGUEROA                1275               LA CA   \n",
       "27          765 THE CITY DRIVE                 NaN          ORANGE, CA   \n",
       "28               8 MILLS PLACE                 NaN        PASADENA, CA   \n",
       "29             126 E OLIVE AVE                 204         BURBANK, CA   \n",
       "30               8370 WILSHIRE                 NaN       BEVERLY HILLS   \n",
       "31         830 S. GLENDALE AVE                 NaN        GLENDALE, CA   \n",
       "32     588 S FREMONT AVE  #803                 NaN              LA, CA   \n",
       "33      11315 WASHINGTON PLACE                 NaN     LOS ANGELES, CA   \n",
       "..                         ...                 ...                 ...   \n",
       "820            11558 KLING ST.                 NaN     N. HOLLYWOOD CA   \n",
       "821         15230 BURBANK BLVD                #106     SHERMAN OAKS,CA   \n",
       "822                        NaN                 NaN                 NaN   \n",
       "823             3200 PEAK ROAD                 NaN        EL MONTE, CA   \n",
       "824         3699 WILSHIRE BLVD                #660     LOS ANGELES, CA   \n",
       "825                        NaN                 NaN                 NaN   \n",
       "826       18201 VON KARMAN AVE                 120          IRVINE, CA   \n",
       "827           5320 YOLANDA AVE                 NaN         TARZANA, CA   \n",
       "828          1623 THOMPSON AVE                 NaN        GLENDALE, CA   \n",
       "829              1544 20TH ST.                 NaN    SANTA MONICA, CA   \n",
       "831   3334 EAST COAST HWY #410                 NaN  CORONA DEL MAR, CA   \n",
       "832  241 SOUTH FIGUEROA STREET                 370     LOS ANGELES, CA   \n",
       "833   11150 W OLYMPIC BLVD#700                 NaN                 NaN   \n",
       "834           8447 WILSHIRE BL                 400   BEVERLY HILLS, CA   \n",
       "835         717 N HIGHLAND AVE                 NaN     LOS ANGELES, CA   \n",
       "836         13547 VENTURA BLVD                 283    SHERMAN OAKS, CA   \n",
       "837           1619 W TEMPLE ST                 NaN     LOS ANGELES, CA   \n",
       "838   8447 WILSHIRE BLVD  #400                 NaN   BEVERLY HILLS, CA   \n",
       "839       639 N LARCHMONT BLVD                 NaN              LA, CA   \n",
       "840                        NaN                 NaN                 NaN   \n",
       "841        9560 WILSHIRE BLVD.                 NaN   BEVERLY HILLS, CA   \n",
       "843        11878 LA GRANGE AVE                 NaN     LOS ANGELES, CA   \n",
       "844         21777 VENTURA BLVD                 234      WOODLAND HILLS   \n",
       "845          650 CALIFORNIA ST             8TH FLR     LOS ANGELES, CA   \n",
       "846        2932 WILSHIRE BLVD.               # 210    SANTA MONICA, CA   \n",
       "849        9530 JEFFERSON BLVD                 NaN     CULVER CITY, CA   \n",
       "850        6087 TRIANGLE DRIVE                 NaN     LOS ANGELES, CA   \n",
       "851  578 WASHINGTON BLVD  #941                 NaN  MARINA DEL REY, CA   \n",
       "852         8370 WILSHIRE BLVD           SUITE 330   BEVERLY HILLS, CA   \n",
       "853         1545 VICTORY BLVD.                #102        GLENDALE, CA   \n",
       "\n",
       "            applicant_business_name applicant_first_name applicant_last_name  \\\n",
       "1                               NaN                 JOSE              GUDIEL   \n",
       "2                               NaN              DOMINIC                HONG   \n",
       "3                               NaN           OCCIDENTAL                 NaN   \n",
       "4                               NaN                FRANK               AFARI   \n",
       "5                               NaN                JASON           MASSABAND   \n",
       "6                               NaN              SHEHZAD              KHALIQ   \n",
       "7                               NaN                  STD              LEMONS   \n",
       "8              JAYCOCAL ENGINEERING                MARIA                CHEN   \n",
       "9                               NaN               MARCUS               PARIS   \n",
       "12                              NaN                 ALEX                 NaN   \n",
       "14                              NaN                 BRAM             JANANTS   \n",
       "15                              BMA                 KIRA              MILLER   \n",
       "16                              NaN              JEFFREY              WARREN   \n",
       "17                              NaN                JAVAD                 NIA   \n",
       "18                              NaN                 JOHN              DODSON   \n",
       "19             JAYCOCAL ENGINEERING                MARIA                CHEN   \n",
       "20                              NaN               DAMIAN              LEMONS   \n",
       "21                              NaN                PETER              WILSON   \n",
       "22                              NaN                JASON               UNGAR   \n",
       "23                              NaN                JAMES             GOODMAN   \n",
       "24                              NaN                KEVIN                TSAI   \n",
       "25                              NaN               ANDREA             SHAPIRO   \n",
       "26                              NaN               JUSTIN              MANALO   \n",
       "27                              NaN              MICHAEL              STANEK   \n",
       "28                              NaN               SHAWNA                 UPP   \n",
       "29                              NaN               SHAHIK          BAGHDASIAN   \n",
       "30                              NaN                JULIA                AUST   \n",
       "31                URIU & ASSOCIATES                  NaN                 NaN   \n",
       "32                              NaN         BRUCE MILLER             & ASSOC   \n",
       "33                              NaN                DAVID           FRUCHTMAN   \n",
       "..                              ...                  ...                 ...   \n",
       "820                             NaN                 FRED             HOFFMAN   \n",
       "821                             NaN              CAMILLA            OLIVEISE   \n",
       "822                             NaN               GEORGE         SEPANOSSIAN   \n",
       "823                             NaN              MATTHEW                FOSS   \n",
       "824                  JS ENGINEERING                CHONG                 LEE   \n",
       "825                  MSH DESIGN INC               MEHRAN           SHAHVERDI   \n",
       "826      SHLEMMER ALGAZE ASSOCIATES              MICHAEL              SYNDER   \n",
       "827                             NaN               ANDREA             SHAPIRO   \n",
       "828                 G&M ENGINEERING               GEORGE              MARKOV   \n",
       "829                             NaN               SANDRA              LOZANO   \n",
       "831                             NaN               HANNAH           GREENBERG   \n",
       "832  KIMBERLINA WHETTAM & ASSOCIATE                 KARA                 NaN   \n",
       "833                             NaN            CHRISTINE             MAALOUF   \n",
       "834                      ETCO HOMES                    E                 NaN   \n",
       "835                             NaN                 MATT             EOKBERG   \n",
       "836                             NaN             CHARLENE              MARTIN   \n",
       "837                             NaN              KRYSTLE               REYES   \n",
       "838                             NaN                 ETCO               HOMES   \n",
       "839                             NaN                 ANDY               LANTZ   \n",
       "840                             NaN                 MARK              JOSTEN   \n",
       "841                             NaN                 MATT              HANSON   \n",
       "843             GMPA ARCHITECTS INC                 GMPA      ARCHITECTS INC   \n",
       "844                             NaN                   RJ             TORBATI   \n",
       "845                             NaN                FLAD&               ASSOC   \n",
       "846                             NaN              DARYOUS               SAFAI   \n",
       "849                             NaN                  BOB                CULL   \n",
       "850          THYSSEN KRUPP ELEVATOR             MARICELA             ESTRADA   \n",
       "851                   OWNER-BUILDER               HUNTER             KENIHAN   \n",
       "852                             NaN               MARTHA                DIAZ   \n",
       "853                             NaN                MOHEB               GORGY   \n",
       "\n",
       "            ...                          street_name street_suffix  \\\n",
       "1           ...                                WORLD           WAY   \n",
       "2           ...                            RIVERSIDE            DR   \n",
       "3           ...                               CAMPUS          ROAD   \n",
       "4           ...                             HARTSOOK            ST   \n",
       "5           ...                               CHALON          ROAD   \n",
       "6           ...                               LOMITA          BLVD   \n",
       "7           ...                                ADAMS          BLVD   \n",
       "8           ...                           LANKERSHIM          BLVD   \n",
       "9           ...                            PENDLETON            ST   \n",
       "12          ...                            HOLLYWOOD          BLVD   \n",
       "14          ...                                ADAMS          BLVD   \n",
       "15          ...                                 PICO          BLVD   \n",
       "16          ...                                  7TH            ST   \n",
       "17          ...                           EXPOSITION          BLVD   \n",
       "18          ...                             FIGUEROA            ST   \n",
       "19          ...                           LANKERSHIM          BLVD   \n",
       "20          ...                               AMALFI            DR   \n",
       "21          ...                           COURTLEIGH            DR   \n",
       "22          ...                              BRISTOL           AVE   \n",
       "23          ...                              PLUMMER            ST   \n",
       "24          ...                             HIGHLAND           AVE   \n",
       "25          ...                        VALLEY SPRING          LANE   \n",
       "26          ...                             WILSHIRE          BLVD   \n",
       "27          ...                                WORLD           WAY   \n",
       "28          ...                                  7TH            ST   \n",
       "29          ...                             TAMARIND           AVE   \n",
       "30          ...                         SANTA MONICA          BLVD   \n",
       "31          ...                              DETROIT            ST   \n",
       "32          ...                                GRAND           AVE   \n",
       "33          ...                           SUNNYSLOPE           AVE   \n",
       "..          ...                                  ...           ...   \n",
       "820         ...                           MULHOLLAND            DR   \n",
       "821         ...                          HIGH VALLEY            PL   \n",
       "822         ...                                 LAKE            ST   \n",
       "823         ...                            LEXINGTON           AVE   \n",
       "824         ...                                 LAKE            ST   \n",
       "825         ...                               CHALON          ROAD   \n",
       "826         ...                               AVALON          BLVD   \n",
       "827         ...                            ROYAL OAK          ROAD   \n",
       "828         ...                                ADAMS          BLVD   \n",
       "829         ...                             OVERLAND           AVE   \n",
       "831         ...                             WILSHIRE          BLVD   \n",
       "832         ...                             FRANKLIN           AVE   \n",
       "833         ...                             BLUE JAY           WAY   \n",
       "834         ...                             TRAMONTO            DR   \n",
       "835         ...                             FIGUEROA            ST   \n",
       "836         ...                              WOODLEY           AVE   \n",
       "837         ...                              MELROSE           AVE   \n",
       "838         ...                             TRAMONTO            DR   \n",
       "839         ...                                  5TH            ST   \n",
       "840         ...                             FIGUEROA            ST   \n",
       "841         ...          ASTRONAUT ELLISON S ONIZUKA            ST   \n",
       "843         ...                            RIVERSIDE            DR   \n",
       "844         ...                               HANLEY           WAY   \n",
       "845         ...                             COLORADO          BLVD   \n",
       "846         ...                              SERRANO           AVE   \n",
       "849         ...                         SANTA MONICA          BLVD   \n",
       "850         ...                             TRAMONTO            DR   \n",
       "851         ...                              SLAUSON           AVE   \n",
       "852         ...                             BROADWAY           NaN   \n",
       "853         ...                        SIERRA BONITA           AVE   \n",
       "\n",
       "    suffix_direction                                              tract  \\\n",
       "1                NaN                              RANCHO SAUSAL REDONDO   \n",
       "2                NaN                                            TR 2590   \n",
       "3                NaN                                             TR 607   \n",
       "4                NaN                                     HARTSOOK TRACT   \n",
       "5                NaN                                            BEL-AIR   \n",
       "6                NaN                                            TR 1589   \n",
       "7                NaN                                            TR 1566   \n",
       "8                NaN                                            TR 2170   \n",
       "9                NaN  LOS ANGELES LAND AND WATER CO'S SUBDIVISION OF...   \n",
       "12               NaN                                           TR 52496   \n",
       "14               NaN                                            TR 1566   \n",
       "15               NaN                                            TR 7861   \n",
       "16               NaN  MUELLER SUBDIVISION OF THE NORTH 1/2 OF BLOCK ...   \n",
       "17               NaN                                             TR 625   \n",
       "18               NaN                                           TR 10196   \n",
       "19               NaN                                            TR 2170   \n",
       "20               NaN                                        THE RIVIERA   \n",
       "21               NaN                                            TR 1971   \n",
       "22               NaN                                     BRENTWOOD PARK   \n",
       "23               NaN                                           TR 23435   \n",
       "24               NaN                                            TR 3569   \n",
       "25               NaN                LANKERSHIM RANCH LAND AND WATER CO.   \n",
       "26               NaN                                        TR 71141-01   \n",
       "27              WEST                              RANCHO SAUSAL REDONDO   \n",
       "28               NaN                                           P M 6524   \n",
       "29               NaN               GRIDER AND HAMILTONS HOLLYWOOD TRACT   \n",
       "30               NaN                                           P M 3784   \n",
       "31               NaN                                            TR 3238   \n",
       "32               NaN                                           TR 30780   \n",
       "33               NaN                                            TR 1000   \n",
       "..               ...                                                ...   \n",
       "820              NaN                                            TR 1000   \n",
       "821              NaN                                           TR 13400   \n",
       "822              NaN         HARBERT AND BUTTERWORTH'S CUMBERLAND TRACT   \n",
       "823              NaN                                CITY BOUNDARY TRACT   \n",
       "824              NaN         HARBERT AND BUTTERWORTH'S CUMBERLAND TRACT   \n",
       "825              NaN              SANTA MONICA LAND AND WATER CO. TRACT   \n",
       "826              NaN                                                NaN   \n",
       "827              NaN                                           TR 13400   \n",
       "828              NaN                                    ELLENDALE PLACE   \n",
       "829              NaN                            CURTIS RESUB. OF BLK. P   \n",
       "831              NaN                                            TR 7555   \n",
       "832              NaN                                            TR 8500   \n",
       "833              NaN                                           TR 19229   \n",
       "834              NaN                                         TR 29827-C   \n",
       "835              NaN                                           TR 45085   \n",
       "836              NaN                                           P M 2458   \n",
       "837              NaN                                             TR 525   \n",
       "838              NaN                                         TR 29827-C   \n",
       "839              NaN                                       NORMAL TRACT   \n",
       "840              NaN                                            TR 4719   \n",
       "841              NaN                                            TR 1666   \n",
       "843              NaN                                            IVANHOE   \n",
       "844              NaN                                           TR 13362   \n",
       "845              NaN                                           P M 2631   \n",
       "846              NaN                                   PELLISSIER TRACT   \n",
       "849              NaN                                           P M 3247   \n",
       "850              NaN                                         TR 29827-C   \n",
       "851              NaN                                           TR 10200   \n",
       "852              NaN                                VICTOR DOL PROPERTY   \n",
       "853              NaN                                             TR 461   \n",
       "\n",
       "    unit_range_end unit_range_start  valuation  \\\n",
       "1              NaN              NaN    1379815   \n",
       "2              NaN              NaN   10500000   \n",
       "3              NaN              NaN    2000000   \n",
       "4               48                1    6008535   \n",
       "5              NaN              NaN    1600000   \n",
       "6              NaN             1-14    2000000   \n",
       "7               10                1    1925000   \n",
       "8              NaN              NaN   40000000   \n",
       "9              NaN              NaN    1200000   \n",
       "12             NaN           C5-525    1800000   \n",
       "14             NaN              NaN    3237681   \n",
       "15             100                1   16188702   \n",
       "16             NaN              NaN    3300000   \n",
       "17             NaN              NaN  1363658.4   \n",
       "18             NaN        1st floor    1235000   \n",
       "19             NaN              NaN   40000000   \n",
       "20             NaN              NaN    1400000   \n",
       "21             NaN              NaN    5000000   \n",
       "22             NaN              NaN    1900000   \n",
       "23             NaN              NaN    1615500   \n",
       "24             NaN              NaN   18953537   \n",
       "25             NaN              NaN    1144000   \n",
       "26             NaN       11th floor    2000000   \n",
       "27             NaN              NaN    5241000   \n",
       "28             NaN          STE 260    1573000   \n",
       "29             NaN              NaN    6300000   \n",
       "30             NaN        UNIT 2540    1428341   \n",
       "31            1-60             1-60   12120505   \n",
       "32       2,4,5,6,7            LEVEL    6290625   \n",
       "33             NaN               4D    7883566   \n",
       "..             ...              ...        ...   \n",
       "820            NaN              NaN    1500000   \n",
       "821            NaN              NaN    1437675   \n",
       "822            NaN              NaN    5000000   \n",
       "823            NaN              NaN    1500000   \n",
       "824            NaN              NaN    5000000   \n",
       "825            NaN              NaN    5600000   \n",
       "826            NaN           BLDG.A    1500000   \n",
       "827            NaN              NaN    1180000   \n",
       "828            NaN              NaN    1500000   \n",
       "829            NaN              NaN    9332001   \n",
       "831            NaN              NaN   12000000   \n",
       "832            NaN              NaN    1200000   \n",
       "833            NaN              NaN    1560000   \n",
       "834            NaN              1-3    2462574   \n",
       "835            NaN              NaN    2757900   \n",
       "836            NaN              NaN    1650000   \n",
       "837            NaN              NaN    5794555   \n",
       "838            NaN              1-2    1296796   \n",
       "839            NaN         FLR 4&11    1750000   \n",
       "840            NaN              NaN   16000000   \n",
       "841            NaN              NaN    2000000   \n",
       "843            120                1    2515428   \n",
       "844            NaN              NaN    1700000   \n",
       "845            NaN           5th FL    1329570   \n",
       "846            NaN              NaN   15928730   \n",
       "849            NaN             1500    1245240   \n",
       "850            NaN              1-8   14400204   \n",
       "851            NaN              NaN    3900000   \n",
       "852            NaN              NaN    3800000   \n",
       "853            NaN              NaN    2400000   \n",
       "\n",
       "                                      work_description zip_code  \\\n",
       "1    SUPPLEMENTAL PERMIT TO 15016-10000-08908.   DE...    90045   \n",
       "2                (N) HOTEL W/ SUBTERANEAN GARAGE BELOW    91607   \n",
       "3    FOUNDATION EARLY START PERMIT ONLY. THIS APPLI...    90032   \n",
       "4    NEW 3-STORY TYPE V-A, 48-UNIT APARTMENT BUILDI...    91601   \n",
       "5    New irregular shape 2- story over 1- level of ...    90077   \n",
       "6                       NEW 14 UNIT APARTMENT BUILDING    90710   \n",
       "7    PROPOSED 3-STORY, 10-UNIT MIXED USE BUILDING W...    90016   \n",
       "8    INSTALLATION OF NEW PLUMBING SYSTEM FOR (2) MI...    91601   \n",
       "9    TI to existing Warehouse to build out accessor...    91352   \n",
       "12   TI at  restaurant  on  the  5th  floor. ENCLOS...    90028   \n",
       "14   NEW 3 STORY MIXED USE,  14 UNIT   APARTEMENT B...    90016   \n",
       "15   PROPOSED 5-STORY, 100 UNIT MIXED USE (97 UNITS...    90064   \n",
       "16   SEISMIC UPGRADE OF 3 STORY CAST-IN-PLACE CONCR...    90014   \n",
       "17   New 4-story office building with parking on th...    90034   \n",
       "18   Interior TI in existing ground floor office bu...    90007   \n",
       "19   INSTALLATION OF NEW HVAC SYSTEM FOR (2) MIXED ...    91601   \n",
       "20                       new 2 story + basement s.f.r.    90272   \n",
       "21   new 29 unit apartment building 4 levels of res...    90066   \n",
       "22   new 2-story SFD with attached garage and basement    90049   \n",
       "23   INSTALL 9 FIRE SPRINKLERS IN NEW 1-HR HALLWAY ...    91311   \n",
       "24   72 UNITS AFFORDABLE APARTMENTS OVER RETAIL AND...    90038   \n",
       "25                               (N) SFD W/ ATT GARAGE    91602   \n",
       "26   INTERIOR TI ON 11TH FLOOR  INCLUDING NEW PARTI...    90017   \n",
       "27   REPLACE 8\"  COMBINED DOMESTIC / FIRE SERVICE L...    90045   \n",
       "28   TENANT IMPROVEMENT TO EXISTING OFFICE SPACE ON...    90021   \n",
       "29   NEW 4 STORY TYPE V-A  32 UNIT APARTMENT BUILDI...    90028   \n",
       "30   T.I. FOR EXISTING RETAIL STORE (UNIT #2540 ); ...    90067   \n",
       "31   PROPOSED  5 STORY,  MIXED USE BUILDING CONSIST...    90046   \n",
       "32   TENANT IMPROVEMENT OF 5 LEVELS.  EACH LEVEL IS...    90071   \n",
       "33   NEW 26 UNIT, 3-STORY APARTMENT BUILDING. PLAN ...    91423   \n",
       "..                                                 ...      ...   \n",
       "820  NEW 2-STORY SFD WITH ATT.  GARAGE & BASEMENT. ...    90210   \n",
       "821  97'-0\" x 107'-0\" TWO STORY SINGLE FAMILY DWELL...    91436   \n",
       "822  NEW HVAC SYSTEM FOR APARTMENT BUILDING.  INCLU...    90026   \n",
       "823  NEW 9-UNIT APARTMENT BUILDING 2 STORY OVER BAS...    90029   \n",
       "824  NEW POTABLE WATER AND WASTE/VENT SYSTEM FOR FO...    90026   \n",
       "825  (N) 2 story SFD with basement and attached gar...    90049   \n",
       "826  <URM>CHANGE OF USE FROM \"STORAGE\" TO \"FOOD MAN...    90003   \n",
       "827  (N) 2-STORY SFD W/ ATTACHED GARAGE (NFPA-13D F...    91436   \n",
       "828  INSTALLATION OF ONE DUPLEX SUMP PUMP SYSTEM FO...    90007   \n",
       "829  New 5-story 60-unit apartment (6-unit very low...    90034   \n",
       "831  NON-DUCTILE SEISMIC RETROFIT PER CHAPTER 95. C...    90048   \n",
       "832  SINGLE FAMILY DWELLING. INSTALL SUMP PUMP AND ...    90069   \n",
       "833                 NEW 1-STORY S.F.D. WITH  BASEMENT.    90069   \n",
       "834  BUILDING 9 (PLAN C) 3 UNITS 4 STORY TYPE IIA A...    90272   \n",
       "835  CONVERT WAREHOUSE TO OFFICE AND MANUFACTURING,...    90248   \n",
       "836  New 2- story irregular shape single family dwe...    91436   \n",
       "837  24 UNIT MIXED USED RESIDENTIAL BUILDING. TWO L...    90029   \n",
       "838  BUILDING 8 (PLAN B2)  2 UNITS  AND 2 STORY TYP...    90272   \n",
       "839  REMOVAL FIVE EXISTING GREENHOUSE ENCLOSURES ON...    90071   \n",
       "840  NEW TWO STORIES ANCILLARY BUILDING WITH ROOF D...    90037   \n",
       "841  PROPOSE 471'-0\" LONG WITH MAX. 33'-0\" HEIGHT T...    90012   \n",
       "843  Temporary shoring (piles only) for new 4-story...    90039   \n",
       "844      new 2 story + basement Single Family dwelling    90049   \n",
       "845  CHANGE OF USE FROM OFFICE TO CONTROL TEST LAB;...    90039   \n",
       "846  PROPOSED 5-STORY, 104-UNIT APARTMENT WITH (9) ...    90006   \n",
       "849  TENANT IMPROVEMENT OF FULL FLOOR LEVEL-15 WITH...    90067   \n",
       "850                       INSTALL HYDRAULIC ELEVATORS.    90272   \n",
       "851  (N) 23 UNIT (21 MARKET RATE, 2 VLI AFFORDABLE)...    90230   \n",
       "852  Core and shell only.  Structural upgrade to ex...    90014   \n",
       "853  NEW 4 STORY TYPE V-A ,  6-UNIT APARTMENT BUILD...    90046   \n",
       "\n",
       "                   zone  \n",
       "1                   LAX  \n",
       "2    (T)(Q)RAS4-1VL-RIO  \n",
       "3                  R1-1  \n",
       "4                R4-1VL  \n",
       "5              RE20-1-H  \n",
       "6             [Q]R3-1VL  \n",
       "7                  C2-1  \n",
       "8               C4-1-CA  \n",
       "9        [Q]M2-1-G-CUGU  \n",
       "12             C4-2D-SN  \n",
       "14            [Q]C2-1VL  \n",
       "15        [Q]C2-1VL-CDO  \n",
       "16                C5-4D  \n",
       "17                 M1-1  \n",
       "18                P-1-O  \n",
       "19              C4-1-CA  \n",
       "20             RE15-1-H  \n",
       "21                 R3-1  \n",
       "22               RE20-1  \n",
       "23                MR2-1  \n",
       "24             C2-1D-SN  \n",
       "25         RE11-1-H-RIO  \n",
       "26             C2-4D-SN  \n",
       "27                  LAX  \n",
       "28                M2-2D  \n",
       "29              [Q]R4-2  \n",
       "30              C2-1L-O  \n",
       "31                 R3-1  \n",
       "32                C2-4D  \n",
       "33           [Q]RD1.5-1  \n",
       "..                  ...  \n",
       "820            RE40-1-H  \n",
       "821            RE15-1-H  \n",
       "822                R4-1  \n",
       "823           RD1.5-1XL  \n",
       "824                R4-1  \n",
       "825            RE20-1-H  \n",
       "826                M2-1  \n",
       "827            RE15-1-H  \n",
       "828             R4-1L-O  \n",
       "829                C2-1  \n",
       "831          [Q]C4-2D-O  \n",
       "832                R1-1  \n",
       "833            RE15-1-H  \n",
       "834               RD2-1  \n",
       "835            M2-1VL-O  \n",
       "836            RE15-1-H  \n",
       "837                C2-1  \n",
       "838               RD2-1  \n",
       "839               C2-4D  \n",
       "840              OS-1XL  \n",
       "841        [Q]C2-4D-CDO  \n",
       "843         RD2-1VL-RIO  \n",
       "844            RE15-1-H  \n",
       "845            M3-1-RIO  \n",
       "846                C2-1  \n",
       "849              C2-2-O  \n",
       "850               RD2-1  \n",
       "851                R3-1  \n",
       "852     [Q]C5-4D-CDO-SN  \n",
       "853                R3-1  \n",
       "\n",
       "[741 rows x 55 columns]"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(len(results_df))\n",
    "print(results_df.keys())\n",
    "print(results_df[\"location_1\"])\n",
    "# DROP ROWS THAT DON'T HAVE LAT OR LONG DATA\n",
    "results_df = results_df.dropna(subset=[\"location_1\"])\n",
    "results_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    },
    {
     "ename": "ValueError",
     "evalue": "cannot insert AOI, already exists",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-69-10afa9a4d8f4>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     25\u001b[0m     \u001b[0ms\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mPolygon\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mshell\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mbox\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"geometry\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"coordinates\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     26\u001b[0m     \u001b[0mshapes\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 27\u001b[0;31m \u001b[0mresults_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0minsert\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mloc\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcolumn\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'AOI'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mpolys\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     28\u001b[0m \u001b[0mresults_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0minsert\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mloc\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcolumn\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'shapes'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mpolys\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     29\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36minsert\u001b[0;34m(self, loc, column, value, allow_duplicates)\u001b[0m\n\u001b[1;32m   2519\u001b[0m         \u001b[0mvalue\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sanitize_column\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcolumn\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mbroadcast\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mFalse\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2520\u001b[0m         self._data.insert(loc, column, value,\n\u001b[0;32m-> 2521\u001b[0;31m                           allow_duplicates=allow_duplicates)\n\u001b[0m\u001b[1;32m   2522\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2523\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0massign\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/internals.pyc\u001b[0m in \u001b[0;36minsert\u001b[0;34m(self, loc, item, value, allow_duplicates)\u001b[0m\n\u001b[1;32m   3808\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mallow_duplicates\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mitem\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3809\u001b[0m             \u001b[0;31m# Should this be a different kind of error??\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3810\u001b[0;31m             \u001b[0;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'cannot insert {}, already exists'\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3811\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3812\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mloc\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mint\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mValueError\u001b[0m: cannot insert AOI, already exists"
     ]
    }
   ],
   "source": [
    "\n",
    "def point_to_box(lon,lat,sz=[350,350]):\n",
    "    # stack overflow copy pasta on lat/lon to meters.\n",
    "    m_per_deg_lat = 111132.954 - 559.822 * math.cos( 2 * lat) + 1.175 * math.cos( 4 * lat)\n",
    "    m_per_deg_lon = 111132.954 * math.cos( lat )\n",
    "    m_per_deg_lat_1 = 1.0 / m_per_deg_lat\n",
    "    m_per_deg_lon_1 = 1.0 / m_per_deg_lon\n",
    "    dx = (sz[0]/2.0)*m_per_deg_lon_1\n",
    "    dy = (sz[1]/2.0)*m_per_deg_lat_1\n",
    "    geom = {\"geometry\": {\n",
    "            \"type\": \"Polygon\",\n",
    "            \"coordinates\": []  }}   \n",
    "    dummy = [[-1.0,-1.0],[-1.0,1.0],[1.0,1.0],[1.0,-1.0],[-1.0,-1.0]]\n",
    "    corners = [[(d[0]*dx)+lon,(d[1]*dy)+lat] for d in dummy]\n",
    "    geom[\"geometry\"][\"coordinates\"].append(corners)\n",
    "    return geom\n",
    "  \n",
    "polys = []\n",
    "shapes = [] \n",
    "print \n",
    "for point in results_df[\"location_1\"].tolist():\n",
    "    p = point[\"coordinates\"]\n",
    "    box = point_to_box(p[0],p[1])\n",
    "    polys.append(box)\n",
    "    s = Polygon(shell=box[\"geometry\"][\"coordinates\"][0])    \n",
    "    shapes.append(s)\n",
    "results_df.insert(loc=0, column='AOI', value=polys)\n",
    "results_df.insert(loc=0, column='shapes', value=polys)\n",
    "\n",
    "results_df.head()\n",
    "len(results_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "0f3fc307a1cb484fb05325f76b0fe610"
      }
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Basemap Mosaic (v1 API)\n",
    "mosaicsSeries = 'global_quarterly_2017q1_mosaic'\n",
    "# Planet tile server base URL (Planet Explorer Mosaics Tiles)\n",
    "mosaicsTilesURL_base = 'https://tiles0.planet.com/experimental/mosaics/planet-tiles/' + mosaicsSeries + '/gmap/{z}/{x}/{y}.png'\n",
    "# Planet tile server url\n",
    "mosaicsTilesURL = mosaicsTilesURL_base + '?api_key=' + PLANET_API_KEY\n",
    "# Map Settings \n",
    "# Define colors\n",
    "colors = {'blue': \"#009da5\"}\n",
    "# Define initial map center lat/long\n",
    "center = [34.0522, -118.2437]\n",
    "# Define initial map zoom level\n",
    "zoom = 9\n",
    "# Set Map Tiles URL\n",
    "planetMapTiles = TileLayer(url= mosaicsTilesURL)\n",
    "# Create the map\n",
    "m = Map(\n",
    "    center=center, \n",
    "    zoom=zoom,\n",
    "    default_tiles = planetMapTiles # Uncomment to use Planet.com basemap\n",
    ")\n",
    "# Define the draw tool type options\n",
    "polygon = {'shapeOptions': {'color': colors['blue']}}\n",
    "rectangle = {'shapeOptions': {'color': colors['blue']}} \n",
    "\n",
    "# Create the draw controls\n",
    "# @see https://github.com/ellisonbg/ipyleaflet/blob/master/ipyleaflet/leaflet.py#L293\n",
    "dc = DrawControl(\n",
    "    polygon = polygon,\n",
    "    rectangle = rectangle\n",
    ")\n",
    "# Initialize an action counter variable\n",
    "actionCount = 0\n",
    "AOIs = {}\n",
    "\n",
    "# Register the draw controls handler\n",
    "def handle_draw(self, action, geo_json):\n",
    "    # Increment the action counter\n",
    "    global actionCount\n",
    "    actionCount += 1\n",
    "    # Remove the `style` property from the GeoJSON\n",
    "    geo_json['properties'] = {}\n",
    "    # Convert geo_json output to a string and prettify (indent & replace ' with \")\n",
    "    geojsonStr = json.dumps(geo_json, indent=2).replace(\"'\", '\"')\n",
    "    AOIs[actionCount] = json.loads(geojsonStr)\n",
    "    \n",
    "\n",
    "    \n",
    "    \n",
    "# Attach the draw handler to the draw controls `on_draw` event\n",
    "dc.on_draw(handle_draw)\n",
    "m.add_control(dc)\n",
    "m\n",
    "\n",
    "for p in polys:\n",
    "    feat = {'geometry':p[\"geometry\"],\"properties\":{\n",
    "            'style':{'color': \"#00FF00\",'fillColor': \"#00FF00\",'fillOpacity': 0.5,'weight': 1}},\n",
    "            'type':u\"Feature\"}\n",
    "    # convert to geojson\n",
    "    gjson = GeoJSON(data=feat)\n",
    "    # add it our map\n",
    "    m.add_layer(gjson)\n",
    "m"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
